2016-04-13 - 26532 - Enhancement - VMP_OPASA_Q007 NAV attribute update #BExQueriesforCrystalReportsAnalysisTool

Enhancement

26532 - VMP_OPASA_Q007 Nav attribute update

Purpose

---

Need to add Customer Group, Customer Sales Rep & Customer Sales manager to the VMP_OPASA_Q007 Analysis Query.

Admin Info

---

Purpose	Need to add customer Sales Rep & Customer Sales manager to the VMP_OPASA_Q007
Requested By	Michael Carducci
Spec Created By	Naveen Gadde
Spec Created Date	04/21/2016
Spec QA by	Uday Kumar P
Objects	VMP_OPASA_Q007
Document Status	Complete

Estimates

---

SNo	Activity	Estimation in Hours
1	Research	02
2	Documentation	01
3	Development/ Config	08
4	Unit test in DEV	02
5	Unit test in QUA	01
6	Other activity	02
	TOTAL	16

References

---

Prior Tickets

None

Documents

None

Spec Changes

---

SNo	Change Details	Requested By	Requested On	Notes if any

Functional Requirement

---

Purpose/WHY:

Email From Mark Harris on 04/21/2016:
Can you look into adding the below fields in the query VMP_OPASA_Q007
1. Adding “Customer [Discount] Groups”.
2. Adding “Sales Rep – Customer” and “Sales Manager – Customer.

In Scope:

None

Out of Scope:

None

Solution Summary

---

1. Need to add Customer Group to open order, contract & condition infocubes.
2. Need to add Customer group to OPASA Multi-providers(Global & Regional).
3. Need to add customer group to VMP_OPASA_Q007.
4. Need to add navigational customer - Sales Rep to VMP_OPASA_Q007.
5. Need to add navigational customer - Sales manager to VMP_OPASA_Q007.
6. Need to validate the changes in BPD.

Test Plan

SNo	Test Scenario	Expected Results
1	Need to check if the Customer Group, Navigational Customer Sales Rep & Navigational Customer Sales Manager are added to VMP_OPASA_Q007 BEx Query.	Customer Group, Navigational Customer Sales Rep & Navigational Customer Sales Manager Should be added to VMP_OPASA_Q007 BEx Query.
2	Need to collect all the changes into the transport successfully.	All the changes should be collected into the transport request.

Solution Details

---

1. Need to add Customer Group to open order ZSDC_OPN, contract ZSD_CONTR & condition ZSD_C15 infocubes.
2. Need to add Customer group to OPASA Multi-providers ZMP_OPASA, ZNA_OPASA, ZEA_OPASA, ZEM_OPASA, ZEJ_OPASA and ZJA_OPASA(Global & Regional).
3. Need to add customer group 0CUST_GROUP to VMP_OPASA_Q007.
4. Need to add navigational customer - Sales Rep 0CUST_SALES_SALES_REP to VMP_OPASA_Q007.
5. Need to add navigational customer - Sales manager 0CUST_SALES_SALES_OFF to VMP_OPASA_Q007.
6. Need to validate the changes in BPD.

Issues

---

None